﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="showjihua.aspx.cs" Inherits="Default3" Title="查看计划单" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">

        .style7
        {
            font-size: small;
            text-align: left;
        }
        .新建样式1
        {
            text-align: center;
        }
        .style8
        {
            font-size: small;
            color: #FF3300;
        }
        .style9
        {
            font-size: small;
        }
        .style21
        {
            font-size: small;
        }
        </style>
        <SCRIPT>
<!--

            top.window.moveTo(0, 0);
            if (document.all) {
                top.window.resizeTo(screen.availWidth, screen.availHeight);
            }
            else if (document.layers || document.getElementById) {
                if (top.window.outerHeight < screen.availHeight || top.window.outerWidth < screen.availWidth) {
                    top.window.outerHeight = screen.availHeight;
                    top.window.outerWidth = screen.availWidth;
                }
            } 

//--> 
</SCRIPT>
</head>
<body background="images/login-bg.jpg">
    <form id="form1" runat="server">
    <div style="text-align: center">
    
    <div class="style7">
    
        <span class="style7">当前位置：</span><asp:HyperLink ID="HyperLink1" runat="server" 
            CssClass="style7" NavigateUrl="~/index.aspx" style="color: #000000" 
            ToolTip="点击返回主页面">主页面</asp:HyperLink>
        <span class="style7">→ 查看计划单</span><br class="style7" />
        <br /></div>
<div>
        <br />
        <br /><b>查看计划单<asp:GridView ID="GridView2" runat="server" 
        AutoGenerateColumns="False" CellPadding="4" DataKeyNames="c_id" 
        DataSourceID="SqlDataSource2" EmptyDataText="没有未提报的计划单" 
        EnableModelValidation="True" ForeColor="#333333" GridLines="None" 
        style="text-align: center; font-size: small" Visible="False" 
            ondatabound="GridView2_DataBound" Font-Bold="False">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="c_id" HeaderText="c_id" InsertVisible="False" 
                ReadOnly="True" SortExpression="c_id" />
                <asp:BoundField DataField="lei" HeaderText="lei" SortExpression="lei" />
                <asp:BoundField DataField="chejian" HeaderText="chejian" 
                SortExpression="chejian" />
                <asp:BoundField DataField="banzu" HeaderText="banzu" SortExpression="banzu" />
                <asp:BoundField DataField="nian" HeaderText="nian" SortExpression="nian" />
                <asp:BoundField DataField="yue" HeaderText="yue" SortExpression="yue" />
                <asp:BoundField DataField="addname" HeaderText="addname" 
                    SortExpression="addname" />
                <asp:BoundField DataField="addtime" HeaderText="addtime" 
                SortExpression="addtime" />
                <asp:BoundField DataField="addip" HeaderText="addip" SortExpression="addip" />
                <asp:BoundField DataField="chejianname" HeaderText="chejianname" 
                    SortExpression="chejianname" />
                <asp:BoundField DataField="chejiantime" HeaderText="chejiantime" 
                    SortExpression="chejiantime" />
                <asp:BoundField DataField="chejianip" HeaderText="chejianip" 
                    SortExpression="chejianip" />
                <asp:BoundField DataField="duanname" HeaderText="duanname" 
                    SortExpression="duanname" />
                <asp:BoundField DataField="duantime" HeaderText="duantime" 
                    SortExpression="duantime" />
                <asp:BoundField DataField="duanip" HeaderText="duanip" 
                    SortExpression="duanip" />
                <asp:BoundField DataField="cailiaoname" HeaderText="cailiaoname" 
                    SortExpression="cailiaoname" />
                <asp:BoundField DataField="cailiaotime" HeaderText="cailiaotime" 
                    SortExpression="cailiaotime" />
                <asp:BoundField DataField="cailiaoip" HeaderText="cailiaoip" 
                    SortExpression="cailiaoip" />
                <asp:BoundField DataField="lingdaoname" HeaderText="lingdaoname" 
                    SortExpression="lingdaoname" />
                <asp:BoundField DataField="lingdaotime" HeaderText="lingdaotime" 
                    SortExpression="lingdaotime" />
                <asp:BoundField DataField="lingdaoip" HeaderText="lingdaoip" 
                    SortExpression="lingdaoip" />
                <asp:BoundField DataField="zt" HeaderText="zt" SortExpression="zt" />
                <asp:BoundField DataField="liezhi" HeaderText="liezhi" 
                    SortExpression="liezhi" />
                <asp:BoundField DataField="faliaoname" HeaderText="faliaoname" 
                    SortExpression="faliaoname" />
                <asp:BoundField DataField="faliaotime" HeaderText="faliaotime" 
                    SortExpression="faliaotime" />
                <asp:BoundField DataField="faliaoip" HeaderText="faliaoip" 
                    SortExpression="faliaoip" />
                <asp:BoundField DataField="qianshouname" HeaderText="qianshouname" 
                    SortExpression="qianshouname" />
                <asp:BoundField DataField="qianshoutime" HeaderText="qianshoutime" 
                    SortExpression="qianshoutime" />
                <asp:BoundField DataField="qianshouip" HeaderText="qianshouip" 
                    SortExpression="qianshouip" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:xxnewsConnectionString %>" 
            
            
            SelectCommand="SELECT * FROM [cailiaoguanli] WHERE ([c_id] = @id) ORDER BY [addtime] DESC">
            <SelectParameters>
                <asp:QueryStringParameter Name="id" QueryStringField="id" />
            </SelectParameters>
        </asp:SqlDataSource>
        <div class="新建样式1">
        <br />
        </b>
            <span class="style9">提报部门：</span><asp:Label ID="Label2" runat="server" 
            style="font-size: small" Text="Label"></asp:Label>
            <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; </b>&nbsp;<span class="style9">类别：<asp:Label ID="Label3" runat="server" 
            style="font-size: small" Text="Label"></asp:Label>
            </span>
                <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
        </b>
            <span class="style9">时间：<asp:Label ID="Label_shijian" runat="server" 
            style="font-size: small" Text="Label"></asp:Label>
            </span><b><br />
        </div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataKeyNames="id" DataSourceID="SqlDataSource1" 
            EnableModelValidation="True" ForeColor="#333333" 
            style="font-size: small; text-align: center" 
            onrowdatabound="GridView1_RowDataBound" Font-Bold="False" 
            ShowFooter="True">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:TemplateField HeaderText="序号"></asp:TemplateField>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" Visible="False" />
                <asp:BoundField DataField="bianhao" HeaderText="物资编码" 
                    SortExpression="bianhao" />
                <asp:BoundField DataField="leibie1" HeaderText="类别" SortExpression="leibie1" />
                <asp:BoundField DataField="leibie2" HeaderText="子类别" SortExpression="leibie2" Visible="False" />
                <asp:BoundField DataField="mingcheng" HeaderText="材料物资名称" 
                    SortExpression="mingcheng" />
                <asp:BoundField DataField="guige" HeaderText="规格型号" SortExpression="guige" 
                    HtmlEncode="False" />
                <asp:BoundField DataField="danwei" HeaderText="单位" SortExpression="danwei" />
                <asp:BoundField DataField="danjia" HeaderText="目录价(元)" SortExpression="danjia" />
                <asp:BoundField DataField="banzushuliang" HeaderText="班组计划数量" 
                    SortExpression="banzushuliang" />
                <asp:BoundField DataField="chejianshuliang" HeaderText="车间审批数量" 
                    SortExpression="chejianshuliang" />
                <asp:BoundField DataField="duanshuliang" HeaderText="段审批数量" 
                    SortExpression="duanshuliang" />
                <asp:BoundField DataField="beizhu" HeaderText="备注" SortExpression="beizhu" />
                <asp:BoundField DataField="daohuoshuliang" HeaderText="发料数量" 
                    SortExpression="daohuoshuliang" />
                <asp:BoundField DataField="qianren" HeaderText="发料人" 
                    SortExpression="qianren" >
                <ItemStyle Width="60px" />
                </asp:BoundField>
                <asp:BoundField DataField="qianrenshijian" HeaderText="发料时间" 
                    SortExpression="qianrenshijian" >
                <ItemStyle Width="60px" />
                </asp:BoundField>
                <asp:BoundField DataField="qianshoushuliang" HeaderText="签收数量" 
                    SortExpression="qianshoushuliang" />
                <asp:BoundField DataField="qianshou" HeaderText="签收人" 
                    SortExpression="qianshou" >
                <ItemStyle Width="60px" />
                </asp:BoundField>
                <asp:BoundField DataField="qianshoushijian" HeaderText="签收时间" 
                    SortExpression="qianshoushijian" >
                <ItemStyle Width="60px" />
                </asp:BoundField>
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
            <HeaderStyle BackColor="#507CD1" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:xxnewsConnectionString %>" 
            SelectCommand="SELECT * FROM [cailiaomingxi] WHERE ([c_id] = @c_id) ORDER BY [bianhao]">
            <SelectParameters>
                <asp:QueryStringParameter Name="c_id" QueryStringField="id" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br /><span class="style9">计划单当前状态：</span><asp:Label ID="Label1" runat="server" 
            CssClass="style8" Text="Label"></asp:Label>
        <br />
        <br />
        <asp:Label ID="Label_tibao" runat="server" 
            style="font-size: small" Text="Label" Font-Bold="False"></asp:Label>
        <br />
        <br />
        <asp:Label ID="Label_chejian" runat="server" 
            style="font-size: small" Text="Label" Font-Bold="False" Visible="False"></asp:Label>
        <br />
        <br />
        <asp:Label ID="Label_duan" runat="server" 
            style="font-size: small" Text="Label" Font-Bold="False" Visible="False"></asp:Label>
        <br />
        <br />
        <asp:Label ID="Label_cailiao" runat="server" 
            style="font-size: small" Text="Label" Font-Bold="False" Visible="False"></asp:Label>
        <br />
        <br />
        <asp:Label ID="Label_faliao" runat="server" 
            style="font-size: small" Text="Label" Font-Bold="False" Visible="False"></asp:Label>
        <br />
        <br />
        <asp:Label ID="Label_qianshou" runat="server" 
            style="font-size: small" Text="Label" Font-Bold="False" Visible="False"></asp:Label>
        </b>
    </div>
    </div>
    </form>
    <p class="style21" style="TEXT-ALIGN: center">
        &nbsp;<br />
        &nbsp;安康供电段信息中心制作 2015</p>
</body>
</html>
